03 March 2025

De-duplication Audit

The de-duplication functionality has an audit table where successful merges can be reviewed. Under the FES schema, the table PEOPLE_DEDUPLICATION_AUDIT stores the following information:

  • merged_from (the old person code)
  • merged_to (the new person code)
  • merged_by
  • merged_on
  • old_surname
  • old_forename
  • old_middle_names
  • old_initials
  • old_dob

This table is only used to review the records that have been deleted. The user will not be able to reverse the de-duplication.